/**
 * Created by luxiaohui on 16/3/25.
 */
// dao/userSqlMapping.js
// CRUD SQL语句
var tableName = 'p_basic_info';
var AssessTable='p_assess';
var CollectTable='collection';
var user = {
    queryDetail:'select * from '+tableName+' where Others=',
    queryDesc:'select * from '+tableName+' where P_Name=',
    queryMark:'select AVG(Mark) as avg_mark from '+AssessTable+' where P_Name=',
    SaveClct:' insert into '+ CollectTable+'(userName,ParkName,ParkAddress,ParkLatlng,SearchType)values(',
    SearchClct:'select * from ' + CollectTable+ ' where userName=',
    DeleteClct:'delete  from ' + CollectTable+ ' where userName=',

};


module.exports = user;